What is pgAdmin 4 and why is it needed?
pgAdmin is the leading open source management tool for Postgres, the world's most advanced open source database.
Today we will talk about this tool and how it helps in the work of Postgres. In the last article, we looked at what PostgreSQL is and some of its aspects. For a better understanding of today's article, check out the last one.
In order not to miss it in the future, I will immediately show you the installation process in this video.
Graphical shell for PostgreSQL
This tool provides a client and a web interface to which you can connect remotely. If you use it on a local network, you won't even need the Internet.
If you wish, you can grant access even to your team. You'll just have to hand out usernames and passwords to connect to the interface.
What is pgAdmin for?
If you have previously worked with databases, you should understand how difficult it is to work through the terminal. The difficulty lies not even in the large number of commands that need to be entered into the terminal, but in the terminal itself. A black window in which over time you can start to get lost and forget which databases were created, which users were added, etc.
This is exactly what the pgAdmin web interface is for. It is very pleasant to the eye and you can immediately see both the created users and the database in it. And in addition, it is much more convenient to create users, give them access to work and track their activity.
How to work in pgAdmin?
If you have a question about working in this control panel, then everything is quite simple. The usage process will not be shown here because the main actions have already been analyzed on our YouTube channel. There you can find answers to various questions.